Create Class from Query Interface

This topic describes the fields that you fill while creating a query-based custom class. Wherever required, it also provides information on the action that you should perform.

The interface is divided into three separate sections, as described in the following tables.

Table 1. Select Tables/Views

Field	Description
Select Database Metadata	The name of the Database Metadata.Click to select the required Database Metadata .
Tables	The tables in the Database Metadata . It is selected by default. Use the navigation buttons to see all the tables. You can select more than one table or all the tables, to build the query.
Views	Select to view the database in its view format.
DB Object	Displays the tables/views in the database.Select the topmost check box to select all the tables/views. Otherwise, navigate through the list of tables using the buttons above the table details area, and select specific tables.

Table 2. Provide Query Details

Field	Description
Type the query here	Represents the SQL query structure where you can provide the relevant details depending upon the field selection, to build the query. It is mandatory to fill the Select field. Note: The query will be invalid if the table name used in the query contains a blank space. In such case, enclose the table name within double quotes (" "). For example, type Order Details as "Order Details".

Table 3. Query Summary

Field	Description
Derived From	The name of the root class from which the query-based custom class is derived.
View Class Name	The name of the query-based custom class that is created. Use this option if you have not selected any class from the Derived From list.

pp108 : Create Class from Query Interface

Create Class from Query Interface